2012-03-23 - 2897.1200 - Spec - CFO Report - EMEA #CrystalReportDevelopment
Specification
2897.1200 - CFO Report - EMEA
Requirement Summary
Create a financial report by region for the CFO of EMEA.
Admin Info
Title
|
CFO Report - EMEA
|
Requested By
|
Alan Jones
|
Spec Created By
|
Kevin Pitkin
|
Spec Created Date
|
03/23/2012
|
Spec QA By
|
Uday Kumar P
|
Objects
|
CFO Report
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
4532_ProjectDef.1200.doc
Functional Requirement
1. To create a single BI Report which displays the following information:
i. The previous year’s actual revenue – 2011
ii. The current years budgeted target – 2012
– this would be hard coded in and supplied by the CFO at the start of the new financial year, or when changes are required.
iii. The current years Shipped revenue figures - 2012
iv. The current years Open order values – 2012
v. The current years Shipped and Open values combined – 2012
vi. The percentage of the combined Shipped and Open values verses the current years budgeted target.
2. The information needs to display:
i. All countries in the EMEA Region.
ii. All Retail locations to be provided for in the same format but not populated
– see note below.
iii. All Values to be shown in GBP.
3. The functionality of the report must allow the following:
i. To export in to Excel.
ii. Certain fields to be manually edited (Retail) – this is where the data cannot be pulled directly from any existing BI data sources. This capability would only be available to the CFO for EMEA.
Solution Summary
Requirement has to completed using the SAP BEx query.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Output Format of the report.
|
Format is as per NEC standards.
|
2
|
Data validation to be performed by NEC.
|
Data validated successfully by NEC.
|
3
|
Report Output format should be Excel.
|
Report Output format is Excel.
|
Solution Details
1. This report is going to be designed using SAP BEx query to fetch Actual Rrevenue for 2012 and 2011, Open value for 2012, Total (Actual Revenue for 2012 +Open value for 2012) value.
2. The output for this report is Excel and report data shows in GBP only. In this report certain fields are edited manually. And the data shows all countries of EMEA Region only.
Issues
None